home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Mastering Web Site Development
/
Microsoft Mastering Web Site Development (Microsoft) (1997).iso
/
Media
/
Ch03
/
W03D004.cc2
< prev
next >
Wrap
Text File
|
1997-04-24
|
2KB
|
30 lines
0, In this demonstration, you will see how to use the
5, ODBC configuration utility to create a data
9, source name. To start the ODBC utility, from the
12, Control Panel double-click the ODBC icon. The ODBC Data
18, Source Admininstrator displays the data source
20, names currently defined on this system. The User DSNs
25, are names that are local to a computer and may
28, only be used by the current user. We'll create a
31, System DSN which will be available to any user. To
36, add a DSN, click Add, select the driver for your
42, database, you must have the appropriate ODBC driver
47, for your database, I'll choose SQL Server, and
50, click Finish. Here, I'll enter a name for the data
54, source, we'll call this StateU2, and a description ù
60, Class Database ù and the name of the server, the SQL
66, server, that has this database. If I click
72, Options, I can specify which database on that server I
78, want to access. And click OK. Now I've added a new
86, data source name to my system. In addition to
91, creating system DSNs, you can create file DSNs. When
95, you create a file DSN, the information is saved to
99, a text file rather than to the registry. When you
103, add a data connection in Visual InterDev, you can
106, use either type of DSN. So in this demonstration,
112, you have seen how to use the ODBC Data Source
115, Administrator to create a data source name. Now that
119, you have a data source name defined in Visual
122, InterDev, you can add a data connection to your
125, project.
129, END